package principal;

public class Main
{
	public static void main(String[] args)
	{
		try
		{
	//		Jexcel j = new Jexcel("src\\test\\UL3A04M.xls");
	//		String[][] ligne = {{"DIS", "", "4", "10"},{"UE Ex","UEER","U123e","10"}};
	//		j.ecrire(18,5,ligne);
			Bd b = Bd.getInstance();
			System.out.println(b.selectMaxNumColonne("UL5AA42"));
	//		b.deconnect();
	//		ImportNote i = new ImportNote();
	//		String[][] tab = i.selectionUesNotees();
			/*for (int j = 0; j < tab.length; j++)
			{
				for (int j2 = 0; j2 < tab[j].length; j2++)
				{
					System.out.print(j2+":"+ tab[j][j2]+" ");
				}
				System.out.println();
			}*/
			
	//		i.importer("src\\test\\UL3A04M.xls", "UL3A04M");
	/*		for(int j = 0 ; j < i.getDonnees().length ; j++ )
			{
				System.out.println(i.getDonnees()[j][0]+" - "+i.getDonnees()[j][1]+" - "+i.getDonnees()[j][2]+" - "+i.getDonnees()[j][3]+" - "+i.getDonnees()[j][4]);
			}*/
		/*	String [][] tab = i.getDonnees();
			for (int j = 0; j < tab.length; j++)
			{
				System.out.println(j);
				for (int j2 = 0; j2 < i.col; j2++)
				{
					System.out.print(j2+":"+ tab[j][j2]+" ");
				}
				System.out.println();
			}*/
	//		ExportEtu e = new ExportEtu();
	//		ExportUE f = new ExportUE();
	//		f.exporter("src\\test\\UE.xls");
	//		e.exporter("src\\test\\UL3A04M.xls");
	//		e.enregistrerControle();
	//		ExportEtu f = new ExportEtu("src\\test\\UL3A04M.xls");
	//		f.exporter();
		//	String l = new String("");
		//	System.out.println(l.substring(0, 1).equalsIgnoreCase("U"));
	/*		Jexcel j = new Jexcel("src\\test\\UL3A04M.xls");
			System.out.println(j.getNbLignes());
			String[] ligne = {"1", "2", "3", "4", "5", "6", "7", "8"};
			String[] ligne = {"2", "ULM12342","Javax","Javax","Javax","Javax","Javax","Javax","Javax"};
			j.ecrire(4,17,ligne);
			String[] l = j.lire(0, 4);
			for(int i = 0 ; i < l.length ; i++)
			{
				System.out.println(i+" : "+l[i].toString());
			}
			Bd.getInstance();
			Jexcel k = new Jexcel("src\\test\\UL3A04M.xls");
			for(int i = 18 ; i < 53 ; i++)
			{
				String l[] = k.lire(i, 1);
				System.out.println(i+" : "+l[0]+" - "+l[1]+" - "+l[2]);
	//			String m[] = {l[0], l[1], l[2], "", l[1]+"."+l[2], "", "etudiant"};
	//			Bd.insertEtu(m);
			}
	*//*		Bd.deconnect();
			Bd.getInstance();
			String [] l = Bd.selectEtu("2095467");
			for(int i = 0 ; i < l.length ; i++)
			{
				System.out.println(i+" : "+l[i]);
			}*/
		}
		catch(Throwable t)
		{
		      System.out.println(t.toString());
		      t.printStackTrace();
		}
	//	System.out.println(e.getDonnees()[83][0]);
	}

}
